Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 1419263 |
| Missing cells | 1609486 |
| Missing cells (%) | 3.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 314.0 MiB |
| Average record size in memory | 232.0 B |
Variable types
| Numeric | 3 |
|---|---|
| Categorical | 24 |
| Boolean | 2 |
Rndrng_Prvdr_Last_Org_Name has a high cardinality: 180859 distinct values | High cardinality |
Rndrng_Prvdr_First_Name has a high cardinality: 49837 distinct values | High cardinality |
Rndrng_Prvdr_Crdntls has a high cardinality: 9299 distinct values | High cardinality |
Rndrng_Prvdr_St1 has a high cardinality: 243256 distinct values | High cardinality |
Rndrng_Prvdr_St2 has a high cardinality: 41274 distinct values | High cardinality |
Rndrng_Prvdr_City has a high cardinality: 10579 distinct values | High cardinality |
Rndrng_Prvdr_State_Abrvtn has a high cardinality: 61 distinct values | High cardinality |
Rndrng_Prvdr_Zip5 has a high cardinality: 19042 distinct values | High cardinality |
Rndrng_Prvdr_Type has a high cardinality: 99 distinct values | High cardinality |
HCPCS_Cd has a high cardinality: 4604 distinct values | High cardinality |
HCPCS_Desc has a high cardinality: 4239 distinct values | High cardinality |
Tot_Benes has a high cardinality: 3691 distinct values | High cardinality |
Tot_Srvcs has a high cardinality: 10080 distinct values | High cardinality |
Tot_Bene_Day_Srvcs has a high cardinality: 5073 distinct values | High cardinality |
Avg_Sbmtd_Chrg has a high cardinality: 128266 distinct values | High cardinality |
Avg_Mdcr_Alowd_Amt has a high cardinality: 68010 distinct values | High cardinality |
Avg_Mdcr_Pymt_Amt has a high cardinality: 59738 distinct values | High cardinality |
Avg_Mdcr_Stdzd_Amt has a high cardinality: 53642 distinct values | High cardinality |
Rndrng_Prvdr_Ent_Cd is highly correlated with Rndrng_Prvdr_Type and 2 other fields | High correlation |
Rndrng_Prvdr_Type is highly correlated with Rndrng_Prvdr_Ent_Cd and 1 other fields | High correlation |
Rndrng_Prvdr_MI is highly correlated with Rndrng_Prvdr_Ent_Cd | High correlation |
Rndrng_Prvdr_Gndr is highly correlated with Rndrng_Prvdr_Ent_Cd | High correlation |
Place_Of_Srvc is highly correlated with Rndrng_Prvdr_Type | High correlation |
Rndrng_Prvdr_Gndr is highly correlated with Rndrng_Prvdr_Type | High correlation |
Rndrng_Prvdr_Ent_Cd is highly correlated with Rndrng_Prvdr_Type | High correlation |
Rndrng_Prvdr_State_Abrvtn is highly correlated with Rndrng_Prvdr_State_FIPS and 3 other fields | High correlation |
Rndrng_Prvdr_State_FIPS is highly correlated with Rndrng_Prvdr_State_Abrvtn and 1 other fields | High correlation |
Rndrng_Prvdr_RUCA is highly correlated with Rndrng_Prvdr_State_Abrvtn and 2 other fields | High correlation |
Rndrng_Prvdr_RUCA_Desc is highly correlated with Rndrng_Prvdr_State_Abrvtn and 1 other fields | High correlation |
Rndrng_Prvdr_Cntry is highly correlated with Rndrng_Prvdr_State_Abrvtn | High correlation |
Rndrng_Prvdr_Type is highly correlated with Rndrng_Prvdr_Gndr and 2 other fields | High correlation |
Place_Of_Srvc is highly correlated with Rndrng_Prvdr_Type | High correlation |
Rndrng_Prvdr_First_Name has 61069 (4.3%) missing values | Missing |
Rndrng_Prvdr_MI has 438461 (30.9%) missing values | Missing |
Rndrng_Prvdr_Crdntls has 110474 (7.8%) missing values | Missing |
Rndrng_Prvdr_Gndr has 61069 (4.3%) missing values | Missing |
Rndrng_Prvdr_St2 has 935854 (65.9%) missing values | Missing |
Rndrng_Prvdr_RUCA is highly skewed (γ1 = 22.65286645) | Skewed |
Reproduction
| Analysis started | 2022-01-15 10:22:18.326433 |
|---|---|
| Analysis finished | 2022-01-15 10:24:57.378226 |
| Duration | 2 minutes and 39.05 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
Rndrng_NPI
Real number (ℝ≥0)
| Distinct | 629503 |
|---|---|
| Distinct (%) | 44.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1499135331 |
| Minimum | 1003000134 |
|---|---|
| Maximum | 1992999825 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.8 MiB |
Quantile statistics
| Minimum | 1003000134 |
|---|---|
| 5-th percentile | 1053303964 |
| Q1 | 1245657278 |
| median | 1497945216 |
| Q3 | 1740622699 |
| 95-th percentile | 1942687785 |
| Maximum | 1992999825 |
| Range | 989999691 |
| Interquartile range (IQR) | 494965421 |
Descriptive statistics
| Standard deviation | 287769373.3 |
|---|---|
| Coefficient of variation (CV) | 0.1919569017 |
| Kurtosis | -1.197802575 |
| Mean | 1499135331 |
| Median Absolute Deviation (MAD) | 242787854 |
| Skewness | -0.01354769181 |
| Sum | 2.127667307 × 1015 |
| Variance | 8.281121223 × 1016 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1366479099 | 90 | < 0.1% |
| 1538144910 | 89 | < 0.1% |
| 1134277494 | 89 | < 0.1% |
| 1891731626 | 87 | < 0.1% |
| 1063497451 | 86 | < 0.1% |
| 1932145778 | 84 | < 0.1% |
| 1205872041 | 80 | < 0.1% |
| 1538105366 | 79 | < 0.1% |
| 1790721538 | 78 | < 0.1% |
| 1881630614 | 77 | < 0.1% |
| Other values (629493) | 1418424 |
| Value | Count | Frequency (%) |
| 1003000134 | 2 | < 0.1% |
| 1003000142 | 1 | < 0.1% |
| 1003000522 | 1 | < 0.1% |
| 1003000530 | 2 | < 0.1% |
| 1003000597 | 9 | |
| 1003000639 | 1 | < 0.1% |
| 1003000738 | 1 | < 0.1% |
| 1003000829 | 1 | < 0.1% |
| 1003000936 | 4 | |
| 1003001041 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1992999825 | 3 | |
| 1992999775 | 1 | < 0.1% |
| 1992999551 | 2 | < 0.1% |
| 1992999437 | 1 | < 0.1% |
| 1992999270 | 1 | < 0.1% |
| 1992999122 | 5 | |
| 1992998736 | 1 | < 0.1% |
| 1992998710 | 1 | < 0.1% |
| 1992998702 | 1 | < 0.1% |
| 1992998645 | 2 | < 0.1% |
| Distinct | 180859 |
|---|---|
| Distinct (%) | 12.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| Patel | 8615 |
|---|---|
| Smith | 7432 |
| Lee | 5285 |
| Johnson | 5247 |
| Walgreen Co | 5082 |
| Other values (180854) |
Length
| Max length | 70 |
|---|---|
| Median length | 6 |
| Mean length | 7.346388936 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 62917 ? |
|---|---|
| Unique (%) | 4.4% |
Sample
| 1st row | Cibull |
|---|---|
| 2nd row | Cibull |
| 3rd row | Khalil |
| 4th row | Weigand |
| 5th row | Semonche |
Common Values
| Value | Count | Frequency (%) |
| Patel | 8615 | 0.6% |
| Smith | 7432 | 0.5% |
| Lee | 5285 | 0.4% |
| Johnson | 5247 | 0.4% |
| Walgreen Co | 5082 | 0.4% |
| Miller | 4341 | 0.3% |
| Brown | 3869 | 0.3% |
| Shah | 3820 | 0.3% |
| Williams | 3758 | 0.3% |
| Jones | 3523 | 0.2% |
| Other values (180849) | 1368291 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| llc | 18825 | 1.2% |
| inc | 17233 | 1.1% |
| patel | 8629 | 0.5% |
| smith | 7527 | 0.5% |
| of | 7435 | 0.5% |
| center | 6518 | 0.4% |
| co | 6464 | 0.4% |
| cvs | 6408 | 0.4% |
| walgreen | 5618 | 0.3% |
| johnson | 5333 | 0.3% |
| Other values (168303) | 1520522 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 49837 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 61069 |
| Missing (%) | 4.3% |
| Memory size | 10.8 MiB |
| Michael | 32465 |
|---|---|
| David | 29756 |
| John | 28498 |
| Robert | 23059 |
| James | 20998 |
| Other values (49832) |
Length
| Max length | 20 |
|---|---|
| Median length | 6 |
| Mean length | 5.934750853 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 16460 ? |
|---|---|
| Unique (%) | 1.2% |
Sample
| 1st row | Thomas |
|---|---|
| 2nd row | Thomas |
| 3rd row | Rashid |
| 4th row | Frederick |
| 5th row | Amanda |
Common Values
| Value | Count | Frequency (%) |
| Michael | 32465 | 2.3% |
| David | 29756 | 2.1% |
| John | 28498 | 2.0% |
| Robert | 23059 | 1.6% |
| James | 20998 | 1.5% |
| William | 16196 | 1.1% |
| Mark | 15693 | 1.1% |
| Richard | 13650 | 1.0% |
| Thomas | 13179 | 0.9% |
| Christopher | 13022 | 0.9% |
| Other values (49827) | 1151678 | |
| (Missing) | 61069 | 4.3% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| michael | 32578 | 2.4% |
| david | 29824 | 2.2% |
| john | 28716 | 2.1% |
| robert | 23085 | 1.7% |
| james | 21047 | 1.5% |
| william | 16237 | 1.2% |
| mark | 15750 | 1.2% |
| richard | 13666 | 1.0% |
| thomas | 13226 | 1.0% |
| christopher | 13057 | 1.0% |
| Other values (46627) | 1160765 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 438461 |
| Missing (%) | 30.9% |
| Memory size | 10.8 MiB |
| A | |
|---|---|
| M | |
| J | |
| L | |
| S | |
| Other values (26) |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | L |
|---|---|
| 2nd row | L |
| 3rd row | J |
| 4th row | M |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| A | 113222 | 8.0% |
| M | 104021 | 7.3% |
| J | 90634 | 6.4% |
| L | 73318 | 5.2% |
| S | 62189 | 4.4% |
| R | 61945 | 4.4% |
| D | 56073 | 4.0% |
| E | 52808 | 3.7% |
| C | 52680 | 3.7% |
| B | 37775 | 2.7% |
| Other values (21) | 276137 | |
| (Missing) | 438461 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| a | 113222 | |
| m | 104021 | 10.6% |
| j | 90634 | 9.2% |
| l | 73318 | 7.5% |
| s | 62189 | 6.3% |
| r | 61945 | 6.3% |
| d | 56073 | 5.7% |
| e | 52808 | 5.4% |
| c | 52680 | 5.4% |
| b | 37775 | 3.9% |
| Other values (17) | 276137 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 9299 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 110474 |
| Missing (%) | 7.8% |
| Memory size | 10.8 MiB |
| M.D. | |
|---|---|
| MD | |
| D.O. | |
| DO | 35988 |
| PA-C | 32275 |
| Other values (9294) |
Length
| Max length | 20 |
|---|---|
| Median length | 4 |
| Mean length | 3.434573487 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4280 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | M.D. |
|---|---|
| 2nd row | M.D. |
| 3rd row | M.D. |
| 4th row | MD |
| 5th row | DO |
Common Values
| Value | Count | Frequency (%) |
| M.D. | 449381 | |
| MD | 442868 | |
| D.O. | 52425 | 3.7% |
| DO | 35988 | 2.5% |
| PA-C | 32275 | 2.3% |
| DPM | 17232 | 1.2% |
| CRNA | 15249 | 1.1% |
| NP | 14802 | 1.0% |
| O.D. | 14577 | 1.0% |
| PA | 13471 | 0.9% |
| Other values (9289) | 220521 | |
| (Missing) | 110474 | 7.8% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| m.d | 474813 | |
| md | 453968 | |
| d.o | 56024 | 4.1% |
| do | 36518 | 2.7% |
| pa-c | 33637 | 2.5% |
| pt | 17609 | 1.3% |
| dpm | 17597 | 1.3% |
| dpt | 16412 | 1.2% |
| crna | 15741 | 1.1% |
| np | 15228 | 1.1% |
| Other values (3539) | 233307 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 61069 |
| Missing (%) | 4.3% |
| Memory size | 10.8 MiB |
| M | |
|---|---|
| F |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | M |
| 5th row | F |
Common Values
| Value | Count | Frequency (%) |
| M | 910650 | |
| F | 447544 | |
| (Missing) | 61069 | 4.3% |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| m | 910650 | |
| f | 447544 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| I | |
|---|---|
| O | 61069 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | I |
|---|---|
| 2nd row | I |
| 3rd row | I |
| 4th row | I |
| 5th row | I |
Common Values
| Value | Count | Frequency (%) |
| I | 1358194 | |
| O | 61069 | 4.3% |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| i | 1358194 | |
| o | 61069 | 4.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 243256 |
|---|---|
| Distinct (%) | 17.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| 200 1st St Sw | 4081 |
|---|---|
| 9500 Euclid Ave | 2440 |
| 4500 San Pablo Rd S | 1509 |
| 75 Francis St | 1408 |
| 200 Hawkins Dr | 1385 |
| Other values (243251) |
Length
| Max length | 55 |
|---|---|
| Median length | 17 |
| Mean length | 17.92835225 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 94418 ? |
|---|---|
| Unique (%) | 6.7% |
Sample
| 1st row | 2650 Ridge Ave |
|---|---|
| 2nd row | 2650 Ridge Ave |
| 3rd row | 4126 N Holland Sylvania Rd |
| 4th row | 1565 Saxon Blvd |
| 5th row | 1021 Park Ave |
Common Values
| Value | Count | Frequency (%) |
| 200 1st St Sw | 4081 | 0.3% |
| 9500 Euclid Ave | 2440 | 0.2% |
| 4500 San Pablo Rd S | 1509 | 0.1% |
| 75 Francis St | 1408 | 0.1% |
| 200 Hawkins Dr | 1385 | 0.1% |
| 5323 Harry Hines Blvd | 1359 | 0.1% |
| 12605 E 16th Ave | 1357 | 0.1% |
| 13400 E Shea Blvd | 1335 | 0.1% |
| 1 Medical Center Dr | 1314 | 0.1% |
| 1515 Holcombe Blvd | 1313 | 0.1% |
| Other values (243246) | 1401762 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| st | 326601 | 5.9% |
| ave | 257019 | 4.7% |
| rd | 229133 | 4.2% |
| dr | 170876 | 3.1% |
| ste | 167024 | 3.0% |
| n | 120869 | 2.2% |
| blvd | 118828 | 2.2% |
| w | 113201 | 2.1% |
| e | 107111 | 1.9% |
| s | 102917 | 1.9% |
| Other values (47201) | 3790751 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 41274 |
|---|---|
| Distinct (%) | 8.5% |
| Missing | 935854 |
| Missing (%) | 65.9% |
| Memory size | 10.8 MiB |
| Suite 200 | 18639 |
|---|---|
| Suite 100 | 17586 |
| Suite 101 | 9444 |
| Suite 300 | 8839 |
| Suite A | 7813 |
| Other values (41269) |
Length
| Max length | 55 |
|---|---|
| Median length | 9 |
| Mean length | 11.48792224 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 16117 ? |
|---|---|
| Unique (%) | 3.3% |
Sample
| 1st row | Evanston Hospital |
|---|---|
| 2nd row | Evanston Hospital |
| 3rd row | Suite 220 |
| 4th row | Suite 102 |
| 5th row | Suite 203 |
Common Values
| Value | Count | Frequency (%) |
| Suite 200 | 18639 | 1.3% |
| Suite 100 | 17586 | 1.2% |
| Suite 101 | 9444 | 0.7% |
| Suite 300 | 8839 | 0.6% |
| Suite A | 7813 | 0.6% |
| Suite 201 | 7629 | 0.5% |
| Suite B | 4964 | 0.3% |
| Suite 102 | 4914 | 0.3% |
| Ste 100 | 4514 | 0.3% |
| Suite 1 | 4444 | 0.3% |
| Other values (41264) | 394623 | |
| (Missing) | 935854 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| suite | 272728 | |
| ste | 68253 | 6.1% |
| 100 | 25514 | 2.3% |
| 200 | 25508 | 2.3% |
| of | 15974 | 1.4% |
| 300 | 13954 | 1.3% |
| 101 | 13741 | 1.2% |
| floor | 12895 | 1.2% |
| a | 12602 | 1.1% |
| department | 12287 | 1.1% |
| Other values (19369) | 641035 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 10579 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| New York | 15341 |
|---|---|
| Houston | 12432 |
| Chicago | 10829 |
| Philadelphia | 9909 |
| Boston | 9177 |
| Other values (10574) |
Length
| Max length | 28 |
|---|---|
| Median length | 9 |
| Mean length | 8.93935303 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1689 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Evanston |
|---|---|
| 2nd row | Evanston |
| 3rd row | Toledo |
| 4th row | Deltona |
| 5th row | Quakertown |
Common Values
| Value | Count | Frequency (%) |
| New York | 15341 | 1.1% |
| Houston | 12432 | 0.9% |
| Chicago | 10829 | 0.8% |
| Philadelphia | 9909 | 0.7% |
| Boston | 9177 | 0.6% |
| Baltimore | 8898 | 0.6% |
| Dallas | 8715 | 0.6% |
| Springfield | 8501 | 0.6% |
| Columbus | 8388 | 0.6% |
| Los Angeles | 8037 | 0.6% |
| Other values (10569) | 1319036 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| city | 34531 | 1.9% |
| new | 29178 | 1.6% |
| san | 22958 | 1.3% |
| beach | 17876 | 1.0% |
| york | 17235 | 0.9% |
| fort | 15986 | 0.9% |
| saint | 13649 | 0.8% |
| park | 13567 | 0.7% |
| houston | 12568 | 0.7% |
| west | 12416 | 0.7% |
| Other values (8304) | 1626737 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 61 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| CA | |
|---|---|
| FL | |
| TX | |
| NY | 90202 |
| PA | 64824 |
| Other values (56) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IL |
|---|---|
| 2nd row | IL |
| 3rd row | OH |
| 4th row | FL |
| 5th row | PA |
Common Values
| Value | Count | Frequency (%) |
| CA | 110538 | 7.8% |
| FL | 102444 | 7.2% |
| TX | 96614 | 6.8% |
| NY | 90202 | 6.4% |
| PA | 64824 | 4.6% |
| IL | 57438 | 4.0% |
| OH | 52053 | 3.7% |
| NC | 51560 | 3.6% |
| MI | 47291 | 3.3% |
| NJ | 44655 | 3.1% |
| Other values (51) | 701644 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| ca | 110538 | 7.8% |
| fl | 102444 | 7.2% |
| tx | 96614 | 6.8% |
| ny | 90202 | 6.4% |
| pa | 64824 | 4.6% |
| il | 57438 | 4.0% |
| oh | 52053 | 3.7% |
| nc | 51560 | 3.6% |
| mi | 47291 | 3.3% |
| nj | 44655 | 3.1% |
| Other values (51) | 701644 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 56 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 853 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.36898711 |
| Minimum | 1 |
|---|---|
| Maximum | 78 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 13 |
| median | 28 |
| Q3 | 42 |
| 95-th percentile | 51 |
| Maximum | 78 |
| Range | 77 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 15.65965276 |
|---|---|
| Coefficient of variation (CV) | 0.5519990087 |
| Kurtosis | -1.133610218 |
| Mean | 28.36898711 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | -0.0001138981059 |
| Sum | 40238855 |
| Variance | 245.2247246 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6 | 110465 | 7.8% |
| 12 | 102515 | 7.2% |
| 48 | 96600 | 6.8% |
| 36 | 90185 | 6.4% |
| 42 | 64823 | 4.6% |
| 17 | 57433 | 4.0% |
| 39 | 52005 | 3.7% |
| 37 | 51558 | 3.6% |
| 26 | 47268 | 3.3% |
| 34 | 44652 | 3.1% |
| Other values (46) | 700906 |
| Value | Count | Frequency (%) |
| 1 | 24523 | 1.7% |
| 2 | 2699 | 0.2% |
| 4 | 29812 | 2.1% |
| 5 | 15542 | 1.1% |
| 6 | 110465 | |
| 8 | 20485 | 1.4% |
| 9 | 18111 | 1.3% |
| 10 | 5366 | 0.4% |
| 11 | 3787 | 0.3% |
| 12 | 102515 |
| Value | Count | Frequency (%) |
| 78 | 218 | < 0.1% |
| 72 | 3575 | 0.3% |
| 69 | 24 | < 0.1% |
| 66 | 233 | < 0.1% |
| 60 | 1 | < 0.1% |
| 56 | 2562 | 0.2% |
| 55 | 25798 | |
| 54 | 8755 | 0.6% |
| 53 | 29439 | |
| 51 | 39681 |
| Distinct | 19042 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| 77030 | 4678 |
|---|---|
| 55905 | 4119 |
| 72205 | 3279 |
| 63110 | 2840 |
| 44195 | 2830 |
| Other values (19037) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.926417443 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2412 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 60201 |
|---|---|
| 2nd row | 60201 |
| 3rd row | 43623 |
| 4th row | 32725 |
| 5th row | 18951 |
Common Values
| Value | Count | Frequency (%) |
| 77030 | 4678 | 0.3% |
| 55905 | 4119 | 0.3% |
| 72205 | 3279 | 0.2% |
| 63110 | 2840 | 0.2% |
| 44195 | 2830 | 0.2% |
| 78229 | 2683 | 0.2% |
| 76104 | 2514 | 0.2% |
| 19104 | 2451 | 0.2% |
| 60611 | 2410 | 0.2% |
| 19107 | 2390 | 0.2% |
| Other values (19032) | 1389069 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 77030 | 4678 | 0.3% |
| 55905 | 4119 | 0.3% |
| 72205 | 3279 | 0.2% |
| 63110 | 2840 | 0.2% |
| 44195 | 2830 | 0.2% |
| 78229 | 2683 | 0.2% |
| 76104 | 2514 | 0.2% |
| 19104 | 2451 | 0.2% |
| 60611 | 2410 | 0.2% |
| 19107 | 2390 | 0.2% |
| Other values (19035) | 1389076 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 853 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.603277684 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.648754583 |
|---|---|
| Coefficient of variation (CV) | 2.275809499 |
| Kurtosis | 596.5544717 |
| Mean | 1.603277684 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.65286645 |
| Sum | 2274105.1 |
| Variance | 13.31341 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=22)
| Value | Count | Frequency (%) |
| 1 | 1204683 | |
| 4 | 96432 | 6.8% |
| 2 | 33643 | 2.4% |
| 7 | 30459 | 2.1% |
| 1.1 | 20985 | 1.5% |
| 10 | 10406 | 0.7% |
| 5 | 6091 | 0.4% |
| 4.1 | 4926 | 0.3% |
| 7.1 | 2002 | 0.1% |
| 3 | 1749 | 0.1% |
| Other values (12) | 7034 | 0.5% |
| Value | Count | Frequency (%) |
| 1 | 1204683 | |
| 1.1 | 20985 | 1.5% |
| 2 | 33643 | 2.4% |
| 2.1 | 591 | < 0.1% |
| 3 | 1749 | 0.1% |
| 4 | 96432 | 6.8% |
| 4.1 | 4926 | 0.3% |
| 5 | 6091 | 0.4% |
| 5.1 | 157 | < 0.1% |
| 6 | 504 | < 0.1% |
| Value | Count | Frequency (%) |
| 99 | 1674 | 0.1% |
| 10.3 | 125 | < 0.1% |
| 10.2 | 564 | < 0.1% |
| 10.1 | 396 | < 0.1% |
| 10 | 10406 | |
| 9 | 633 | < 0.1% |
| 8.2 | 15 | < 0.1% |
| 8.1 | 7 | < 0.1% |
| 8 | 1476 | 0.1% |
| 7.2 | 892 | 0.1% |
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 853 |
| Missing (%) | 0.1% |
| Memory size | 10.8 MiB |
| Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | |
|---|---|
| Micropolitan area core: primary flow within an urban cluster of 10,000 to 49,999 | 96432 |
| Metropolitan area high commuting: primary flow 30% or more to a urbanized area of 50,000 and greater | 33643 |
| Small town core: primary flow within an urban cluster of 2,500 to 9,999 | 30459 |
| Secondary flow 30% to <50% to a larger urbanized area of 50,000 and greater | 21576 |
| Other values (10) | 31617 |
Length
| Max length | 100 |
|---|---|
| Median length | 83 |
| Mean length | 82.74279651 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater |
|---|---|
| 2nd row | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater |
| 3rd row | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater |
| 4th row | Secondary flow 30% to <50% to a larger urbanized area of 50,000 and greater |
| 5th row | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater |
Common Values
| Value | Count | Frequency (%) |
| Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | 1204683 | |
| Micropolitan area core: primary flow within an urban cluster of 10,000 to 49,999 | 96432 | 6.8% |
| Metropolitan area high commuting: primary flow 30% or more to a urbanized area of 50,000 and greater | 33643 | 2.4% |
| Small town core: primary flow within an urban cluster of 2,500 to 9,999 | 30459 | 2.1% |
| Secondary flow 30% to <50% to a larger urbanized area of 50,000 and greater | 21576 | 1.5% |
| Rural areas: primary flow to a tract outside a urbanized area of 50,000 and greater or UC | 10406 | 0.7% |
| Secondary flow 30% to <50% to a urbanized area of 50,000 and greater | 7488 | 0.5% |
| Micropolitan high commuting: primary flow 30% or more to a urban cluster of 10,000 to 49,999 | 6091 | 0.4% |
| Metropolitan area low commuting: primary flow 10% to <30% to a urbanized area of 50,000 and greater | 1749 | 0.1% |
| Unknown | 1674 | 0.1% |
| Other values (5) | 4209 | 0.3% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| area | 2616052 | |
| flow | 1416736 | 7.6% |
| of | 1416736 | 7.6% |
| primary | 1386076 | 7.4% |
| core | 1331574 | 7.1% |
| within | 1331574 | 7.1% |
| an | 1331574 | 7.1% |
| and | 1279545 | 6.9% |
| greater | 1279545 | 6.9% |
| urbanized | 1279545 | 6.9% |
| Other values (29) | 3983274 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| US | |
|---|---|
| JP | 21 |
| CA | 11 |
| JO | 8 |
| DE | 7 |
| Other values (14) | 50 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
Common Values
| Value | Count | Frequency (%) |
| US | 1419166 | |
| JP | 21 | < 0.1% |
| CA | 11 | < 0.1% |
| JO | 8 | < 0.1% |
| DE | 7 | < 0.1% |
| LB | 6 | < 0.1% |
| TH | 6 | < 0.1% |
| GB | 6 | < 0.1% |
| TR | 5 | < 0.1% |
| IT | 5 | < 0.1% |
| Other values (9) | 22 | < 0.1% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| us | 1419166 | |
| jp | 21 | < 0.1% |
| ca | 11 | < 0.1% |
| jo | 8 | < 0.1% |
| de | 7 | < 0.1% |
| lb | 6 | < 0.1% |
| th | 6 | < 0.1% |
| gb | 6 | < 0.1% |
| it | 5 | < 0.1% |
| tr | 5 | < 0.1% |
| Other values (9) | 22 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| Diagnostic Radiology | |
|---|---|
| Internal Medicine | |
| Family Practice | |
| Nurse Practitioner | |
| Physician Assistant | 62410 |
| Other values (94) |
Length
| Max length | 55 |
|---|---|
| Median length | 17 |
| Mean length | 17.88965611 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Pathology |
|---|---|
| 2nd row | Pathology |
| 3rd row | Anesthesiology |
| 4th row | Family Practice |
| 5th row | Internal Medicine |
Common Values
| Value | Count | Frequency (%) |
| Diagnostic Radiology | 175963 | 12.4% |
| Internal Medicine | 142736 | 10.1% |
| Family Practice | 131193 | 9.2% |
| Nurse Practitioner | 98738 | 7.0% |
| Physician Assistant | 62410 | 4.4% |
| Cardiology | 59880 | 4.2% |
| Physical Therapist in Private Practice | 44709 | 3.2% |
| Orthopedic Surgery | 40875 | 2.9% |
| Anesthesiology | 34588 | 2.4% |
| Ophthalmology | 33476 | 2.4% |
| Other values (89) | 594695 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| medicine | 196255 | 7.1% |
| practice | 185058 | 6.7% |
| radiology | 183415 | 6.6% |
| diagnostic | 180522 | 6.5% |
| internal | 142736 | 5.1% |
| family | 131193 | 4.7% |
| nurse | 118571 | 4.3% |
| practitioner | 98738 | 3.5% |
| surgery | 84413 | 3.0% |
| cardiology | 74034 | 2.7% |
| Other values (150) | 1387052 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| True | |
|---|---|
| False | 451 |
| Value | Count | Frequency (%) |
| True | 1418812 | |
| False | 451 | < 0.1% |
| Distinct | 4604 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| 99213 | 65930 |
|---|---|
| 99214 | 64193 |
| 99204 | 26519 |
| 99203 | 25383 |
| 99232 | 25211 |
| Other values (4599) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 779 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 88341 |
|---|---|
| 2nd row | 88348 |
| 3rd row | 99213 |
| 4th row | 99204 |
| 5th row | 90662 |
Common Values
| Value | Count | Frequency (%) |
| 99213 | 65930 | 4.6% |
| 99214 | 64193 | 4.5% |
| 99204 | 26519 | 1.9% |
| 99203 | 25383 | 1.8% |
| 99232 | 25211 | 1.8% |
| G0008 | 20180 | 1.4% |
| 99223 | 19237 | 1.4% |
| 99233 | 17891 | 1.3% |
| 99215 | 17817 | 1.3% |
| 99212 | 16686 | 1.2% |
| Other values (4594) | 1120216 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 99213 | 65930 | 4.6% |
| 99214 | 64193 | 4.5% |
| 99204 | 26519 | 1.9% |
| 99203 | 25383 | 1.8% |
| 99232 | 25211 | 1.8% |
| g0008 | 20180 | 1.4% |
| 99223 | 19237 | 1.4% |
| 99233 | 17891 | 1.3% |
| 99215 | 17817 | 1.3% |
| 99212 | 16686 | 1.2% |
| Other values (4594) | 1120216 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 4239 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| Established patient office or other outpatient visit, typically 15 minutes | 65930 |
|---|---|
| Established patient office or other outpatient, visit typically 25 minutes | 64193 |
| New patient office or other outpatient visit, typically 45 minutes | 26519 |
| New patient office or other outpatient visit, typically 30 minutes | 25383 |
| Subsequent hospital inpatient care, typically 25 minutes per day | 25211 |
| Other values (4234) |
Length
| Max length | 256 |
|---|---|
| Median length | 61 |
| Mean length | 61.42576323 |
| Min length | 6 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 688 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Special stained specimen slides to examine tissue |
|---|---|
| 2nd row | Electron microscopy for diagnosis |
| 3rd row | Established patient office or other outpatient visit, typically 15 minutes |
| 4th row | New patient office or other outpatient visit, typically 45 minutes |
| 5th row | Vaccine for influenza for injection into muscle |
Common Values
| Value | Count | Frequency (%) |
| Established patient office or other outpatient visit, typically 15 minutes | 65930 | 4.6% |
| Established patient office or other outpatient, visit typically 25 minutes | 64193 | 4.5% |
| New patient office or other outpatient visit, typically 45 minutes | 26519 | 1.9% |
| New patient office or other outpatient visit, typically 30 minutes | 25383 | 1.8% |
| Subsequent hospital inpatient care, typically 25 minutes per day | 25211 | 1.8% |
| Administration of influenza virus vaccine | 20180 | 1.4% |
| Vaccine for influenza for injection into muscle | 19985 | 1.4% |
| Initial hospital inpatient care, typically 70 minutes per day | 19237 | 1.4% |
| Subsequent hospital inpatient care, typically 35 minutes per day | 17891 | 1.3% |
| Established patient office or other outpatient, visit typically 40 minutes | 17817 | 1.3% |
| Other values (4229) | 1116917 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| of | 766603 | 6.0% |
| or | 502526 | 3.9% |
| minutes | 461110 | 3.6% |
| typically | 376220 | 2.9% |
| visit | 322261 | 2.5% |
| patient | 304113 | 2.4% |
| and | 251909 | 2.0% |
| other | 244826 | 1.9% |
| outpatient | 236534 | 1.8% |
| office | 236255 | 1.8% |
| Other values (3503) | 9103205 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
HCPCS_Drug_Ind
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| False | |
|---|---|
| True | 87372 |
| Value | Count | Frequency (%) |
| False | 1331891 | |
| True | 87372 | 6.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| O | |
|---|---|
| F |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | F |
|---|---|
| 2nd row | F |
| 3rd row | F |
| 4th row | O |
| 5th row | O |
Common Values
| Value | Count | Frequency (%) |
| O | 875453 | |
| F | 543810 |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| o | 875453 | |
| f | 543810 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3691 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| 11 | 69540 |
|---|---|
| 12 | 61948 |
| 13 | 55465 |
| 14 | 50197 |
| 15 | 45533 |
| Other values (3686) |
Length
| Max length | 7 |
|---|---|
| Median length | 2 |
| Mean length | 2.193651212 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1707 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 93 |
|---|---|
| 2nd row | 22 |
| 3rd row | 24 |
| 4th row | 25 |
| 5th row | 93 |
Common Values
| Value | Count | Frequency (%) |
| 11 | 69540 | 4.9% |
| 12 | 61948 | 4.4% |
| 13 | 55465 | 3.9% |
| 14 | 50197 | 3.5% |
| 15 | 45533 | 3.2% |
| 16 | 41787 | 2.9% |
| 17 | 38336 | 2.7% |
| 18 | 35546 | 2.5% |
| 19 | 32649 | 2.3% |
| 20 | 31025 | 2.2% |
| Other values (3681) | 957237 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 11 | 69540 | 4.9% |
| 12 | 61948 | 4.4% |
| 13 | 55465 | 3.9% |
| 14 | 50197 | 3.5% |
| 15 | 45533 | 3.2% |
| 16 | 41787 | 2.9% |
| 17 | 38336 | 2.7% |
| 18 | 35546 | 2.5% |
| 19 | 32649 | 2.3% |
| 20 | 31025 | 2.2% |
| Other values (3681) | 957237 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 10080 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| 12 | 44049 |
|---|---|
| 13 | 42054 |
| 11 | 40839 |
| 14 | 39678 |
| 15 | 37129 |
| Other values (10075) |
Length
| Max length | 11 |
|---|---|
| Median length | 2 |
| Mean length | 2.34128206 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 5287 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 322 |
|---|---|
| 2nd row | 22 |
| 3rd row | 28 |
| 4th row | 25 |
| 5th row | 99 |
Common Values
| Value | Count | Frequency (%) |
| 12 | 44049 | 3.1% |
| 13 | 42054 | 3.0% |
| 11 | 40839 | 2.9% |
| 14 | 39678 | 2.8% |
| 15 | 37129 | 2.6% |
| 16 | 34801 | 2.5% |
| 17 | 32394 | 2.3% |
| 18 | 30377 | 2.1% |
| 19 | 28456 | 2.0% |
| 20 | 27091 | 1.9% |
| Other values (10070) | 1062395 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 12 | 44049 | 3.1% |
| 13 | 42054 | 3.0% |
| 11 | 40839 | 2.9% |
| 14 | 39678 | 2.8% |
| 15 | 37129 | 2.6% |
| 16 | 34801 | 2.5% |
| 17 | 32394 | 2.3% |
| 18 | 30377 | 2.1% |
| 19 | 28456 | 2.0% |
| 20 | 27091 | 1.9% |
| Other values (10070) | 1062395 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 5073 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| 12 | 47081 |
|---|---|
| 11 | 44782 |
| 13 | 44557 |
| 14 | 41677 |
| 15 | 38851 |
| Other values (5068) |
Length
| Max length | 9 |
|---|---|
| Median length | 2 |
| Mean length | 2.291354034 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2005 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 98 |
|---|---|
| 2nd row | 22 |
| 3rd row | 28 |
| 4th row | 25 |
| 5th row | 99 |
Common Values
| Value | Count | Frequency (%) |
| 12 | 47081 | 3.3% |
| 11 | 44782 | 3.2% |
| 13 | 44557 | 3.1% |
| 14 | 41677 | 2.9% |
| 15 | 38851 | 2.7% |
| 16 | 36380 | 2.6% |
| 17 | 33796 | 2.4% |
| 18 | 31659 | 2.2% |
| 19 | 29477 | 2.1% |
| 20 | 28144 | 2.0% |
| Other values (5063) | 1042859 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 12 | 47081 | 3.3% |
| 11 | 44782 | 3.2% |
| 13 | 44557 | 3.1% |
| 14 | 41677 | 2.9% |
| 15 | 38851 | 2.7% |
| 16 | 36380 | 2.6% |
| 17 | 33796 | 2.4% |
| 18 | 31659 | 2.2% |
| 19 | 29477 | 2.1% |
| 20 | 28144 | 2.0% |
| Other values (5063) | 1042859 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 128266 |
|---|---|
| Distinct (%) | 9.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| $150.00 | 13848 |
|---|---|
| $50.00 | 13005 |
| $100.00 | 11912 |
| $30.00 | 11504 |
| $40.00 | 10444 |
| Other values (128261) |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 6.764222699 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 59441 ? |
|---|---|
| Unique (%) | 4.2% |
Sample
| 1st row | $92.00 |
|---|---|
| 2nd row | $350.00 |
| 3rd row | $96.00 |
| 4th row | $499.00 |
| 5th row | $82.73 |
Common Values
| Value | Count | Frequency (%) |
| $150.00 | 13848 | 1.0% |
| $50.00 | 13005 | 0.9% |
| $100.00 | 11912 | 0.8% |
| $30.00 | 11504 | 0.8% |
| $40.00 | 10444 | 0.7% |
| $200.00 | 10412 | 0.7% |
| $25.00 | 10097 | 0.7% |
| $35.00 | 9661 | 0.7% |
| $60.00 | 9526 | 0.7% |
| $75.00 | 9014 | 0.6% |
| Other values (128256) | 1309840 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 150.00 | 13848 | 1.0% |
| 50.00 | 13005 | 0.9% |
| 100.00 | 11912 | 0.8% |
| 30.00 | 11504 | 0.8% |
| 40.00 | 10444 | 0.7% |
| 200.00 | 10412 | 0.7% |
| 25.00 | 10097 | 0.7% |
| 35.00 | 9661 | 0.7% |
| 60.00 | 9526 | 0.7% |
| 75.00 | 9014 | 0.6% |
| Other values (128256) | 1309840 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 68010 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| $2.94 | 9681 |
|---|---|
| $2.44 | 5874 |
| $18.65 | 5096 |
| $3.41 | 4769 |
| $10.57 | 4536 |
| Other values (68005) |
Length
| Max length | 10 |
|---|---|
| Median length | 6 |
| Mean length | 6.224355176 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 28828 ? |
|---|---|
| Unique (%) | 2.0% |
Sample
| 1st row | $30.63 |
|---|---|
| 2nd row | $81.68 |
| 3rd row | $48.82 |
| 4th row | $165.77 |
| 5th row | $54.65 |
Common Values
| Value | Count | Frequency (%) |
| $2.94 | 9681 | 0.7% |
| $2.44 | 5874 | 0.4% |
| $18.65 | 5096 | 0.4% |
| $3.41 | 4769 | 0.3% |
| $10.57 | 4536 | 0.3% |
| $54.89 | 4179 | 0.3% |
| $4.28 | 3363 | 0.2% |
| $8.46 | 3342 | 0.2% |
| $0.11 | 2881 | 0.2% |
| $11.51 | 2542 | 0.2% |
| Other values (68000) | 1373000 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2.94 | 9681 | 0.7% |
| 2.44 | 5874 | 0.4% |
| 18.65 | 5096 | 0.4% |
| 3.41 | 4769 | 0.3% |
| 10.57 | 4536 | 0.3% |
| 54.89 | 4179 | 0.3% |
| 4.28 | 3363 | 0.2% |
| 8.46 | 3342 | 0.2% |
| 0.11 | 2881 | 0.2% |
| 11.51 | 2542 | 0.2% |
| Other values (68000) | 1373000 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 59738 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| $2.94 | 9688 |
|---|---|
| $2.44 | 5811 |
| $18.65 | 5100 |
| $3.41 | 4792 |
| $10.57 | 4570 |
| Other values (59733) |
Length
| Max length | 10 |
|---|---|
| Median length | 6 |
| Mean length | 6.069952504 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 25313 ? |
|---|---|
| Unique (%) | 1.8% |
Sample
| 1st row | $24.49 |
|---|---|
| 2nd row | $65.30 |
| 3rd row | $30.35 |
| 4th row | $98.33 |
| 5th row | $54.65 |
Common Values
| Value | Count | Frequency (%) |
| $2.94 | 9688 | 0.7% |
| $2.44 | 5811 | 0.4% |
| $18.65 | 5100 | 0.4% |
| $3.41 | 4792 | 0.3% |
| $10.57 | 4570 | 0.3% |
| $54.89 | 4261 | 0.3% |
| $0.09 | 3399 | 0.2% |
| $4.28 | 3391 | 0.2% |
| $8.46 | 3240 | 0.2% |
| $11.51 | 2509 | 0.2% |
| Other values (59728) | 1372502 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2.94 | 9688 | 0.7% |
| 2.44 | 5811 | 0.4% |
| 18.65 | 5100 | 0.4% |
| 3.41 | 4792 | 0.3% |
| 10.57 | 4570 | 0.3% |
| 54.89 | 4261 | 0.3% |
| 0.09 | 3399 | 0.2% |
| 4.28 | 3391 | 0.2% |
| 8.46 | 3240 | 0.2% |
| 11.51 | 2509 | 0.2% |
| Other values (59728) | 1372502 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 53642 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| $16.60 | 24613 |
|---|---|
| $2.94 | 14065 |
| $115.84 | 9099 |
| $2.44 | 7300 |
| $10.57 | 6615 |
| Other values (53637) |
Length
| Max length | 10 |
|---|---|
| Median length | 6 |
| Mean length | 6.07057043 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 21509 ? |
|---|---|
| Unique (%) | 1.5% |
Sample
| 1st row | $23.45 |
|---|---|
| 2nd row | $62.44 |
| 3rd row | $32.58 |
| 4th row | $97.31 |
| 5th row | $54.65 |
Common Values
| Value | Count | Frequency (%) |
| $16.60 | 24613 | 1.7% |
| $2.94 | 14065 | 1.0% |
| $115.84 | 9099 | 0.6% |
| $2.44 | 7300 | 0.5% |
| $10.57 | 6615 | 0.5% |
| $82.79 | 6386 | 0.4% |
| $3.41 | 5831 | 0.4% |
| $57.92 | 5620 | 0.4% |
| $58.20 | 5278 | 0.4% |
| $8.46 | 5201 | 0.4% |
| Other values (53632) | 1329255 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 16.60 | 24613 | 1.7% |
| 2.94 | 14065 | 1.0% |
| 115.84 | 9099 | 0.6% |
| 2.44 | 7300 | 0.5% |
| 10.57 | 6615 | 0.5% |
| 82.79 | 6386 | 0.4% |
| 3.41 | 5831 | 0.4% |
| 57.92 | 5620 | 0.4% |
| 58.20 | 5278 | 0.4% |
| 8.46 | 5201 | 0.4% |
| Other values (53632) | 1329255 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.
First rows
| Rndrng_NPI | Rndrng_Prvdr_Last_Org_Name | Rndrng_Prvdr_First_Name | Rndrng_Prvdr_MI | Rndrng_Prvdr_Crdntls | Rndrng_Prvdr_Gndr | Rndrng_Prvdr_Ent_Cd | Rndrng_Prvdr_St1 | Rndrng_Prvdr_St2 | Rndrng_Prvdr_City | Rndrng_Prvdr_State_Abrvtn | Rndrng_Prvdr_State_FIPS | Rndrng_Prvdr_Zip5 | Rndrng_Prvdr_RUCA | Rndrng_Prvdr_RUCA_Desc | Rndrng_Prvdr_Cntry | Rndrng_Prvdr_Type | Rndrng_Prvdr_Mdcr_Prtcptg_Ind | HCPCS_Cd | HCPCS_Desc | HCPCS_Drug_Ind | Place_Of_Srvc | Tot_Benes | Tot_Srvcs | Tot_Bene_Day_Srvcs | Avg_Sbmtd_Chrg | Avg_Mdcr_Alowd_Amt | Avg_Mdcr_Pymt_Amt | Avg_Mdcr_Stdzd_Amt | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1003000134 | Cibull | Thomas | L | M.D. | M | I | 2650 Ridge Ave | Evanston Hospital | Evanston | IL | 17.0 | 60201 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Pathology | Y | 88341 | Special stained specimen slides to examine tissue | N | F | 93 | 322 | 98 | $92.00 | $30.63 | $24.49 | $23.45 |
| 1 | 1003000134 | Cibull | Thomas | L | M.D. | M | I | 2650 Ridge Ave | Evanston Hospital | Evanston | IL | 17.0 | 60201 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Pathology | Y | 88348 | Electron microscopy for diagnosis | N | F | 22 | 22 | 22 | $350.00 | $81.68 | $65.30 | $62.44 |
| 2 | 1003000142 | Khalil | Rashid | NaN | M.D. | M | I | 4126 N Holland Sylvania Rd | Suite 220 | Toledo | OH | 39.0 | 43623 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Anesthesiology | Y | 99213 | Established patient office or other outpatient visit, typically 15 minutes | N | F | 24 | 28 | 28 | $96.00 | $48.82 | $30.35 | $32.58 |
| 3 | 1003000522 | Weigand | Frederick | J | MD | M | I | 1565 Saxon Blvd | Suite 102 | Deltona | FL | 12.0 | 32725 | 1.1 | Secondary flow 30% to <50% to a larger urbanized area of 50,000 and greater | US | Family Practice | Y | 99204 | New patient office or other outpatient visit, typically 45 minutes | N | O | 25 | 25 | 25 | $499.00 | $165.77 | $98.33 | $97.31 |
| 4 | 1003000530 | Semonche | Amanda | M | DO | F | I | 1021 Park Ave | Suite 203 | Quakertown | PA | 42.0 | 18951 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Internal Medicine | Y | 90662 | Vaccine for influenza for injection into muscle | Y | O | 93 | 99 | 99 | $82.73 | $54.65 | $54.65 | $54.65 |
| 5 | 1003000530 | Semonche | Amanda | M | DO | F | I | 1021 Park Ave | Suite 203 | Quakertown | PA | 42.0 | 18951 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Internal Medicine | Y | 99496 | Transitional care management services, highly complexity, requiring face-to-face visits within 7 days of discharge | N | O | 11 | 13 | 13 | $404.23 | $245.10 | $183.94 | $173.07 |
| 6 | 1003000597 | Kim | Dae | Y | M.D., PH.D | M | I | 1145 S Utica Ave | Suite 202 | Tulsa | OK | 40.0 | 74104 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Urology | Y | 51702 | Insertion of indwelling bladder catheter | N | O | 16 | 22 | 22 | $212.00 | $58.49 | $44.64 | $47.68 |
| 7 | 1003000597 | Kim | Dae | Y | M.D., PH.D | M | I | 1145 S Utica Ave | Suite 202 | Tulsa | OK | 40.0 | 74104 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Urology | Y | 51741 | Electronic assessment of bladder emptying | N | O | 86 | 96 | 96 | $34.00 | $13.42 | $10.16 | $10.67 |
| 8 | 1003000597 | Kim | Dae | Y | M.D., PH.D | M | I | 1145 S Utica Ave | Suite 202 | Tulsa | OK | 40.0 | 74104 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Urology | Y | 51798 | Ultrasound measurement of bladder capacity after voiding | N | O | 199 | 233 | 233 | $32.00 | $11.56 | $9.05 | $9.98 |
| 9 | 1003000597 | Kim | Dae | Y | M.D., PH.D | M | I | 1145 S Utica Ave | Suite 202 | Tulsa | OK | 40.0 | 74104 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Urology | Y | 52204 | Biopsy of the bladder using an endoscope | N | F | 22 | 22 | 22 | $745.00 | $134.65 | $106.14 | $107.04 |
Last rows
| Rndrng_NPI | Rndrng_Prvdr_Last_Org_Name | Rndrng_Prvdr_First_Name | Rndrng_Prvdr_MI | Rndrng_Prvdr_Crdntls | Rndrng_Prvdr_Gndr | Rndrng_Prvdr_Ent_Cd | Rndrng_Prvdr_St1 | Rndrng_Prvdr_St2 | Rndrng_Prvdr_City | Rndrng_Prvdr_State_Abrvtn | Rndrng_Prvdr_State_FIPS | Rndrng_Prvdr_Zip5 | Rndrng_Prvdr_RUCA | Rndrng_Prvdr_RUCA_Desc | Rndrng_Prvdr_Cntry | Rndrng_Prvdr_Type | Rndrng_Prvdr_Mdcr_Prtcptg_Ind | HCPCS_Cd | HCPCS_Desc | HCPCS_Drug_Ind | Place_Of_Srvc | Tot_Benes | Tot_Srvcs | Tot_Bene_Day_Srvcs | Avg_Sbmtd_Chrg | Avg_Mdcr_Alowd_Amt | Avg_Mdcr_Pymt_Amt | Avg_Mdcr_Stdzd_Amt | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1419253 | 1992999122 | Johnson | Charles | R | D.O. | M | I | 1601 Clint Moore Rd | 155 | Boca Raton | FL | 12.0 | 33487 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Internal Medicine | Y | G0403 | Electrocardiogram, routine ecg with 12 leads; performed as a screening for the initial preventive physical examination with interpretation and report | N | O | 25 | 25 | 25 | $25.00 | $17.85 | $9.64 | $9.22 |
| 1419254 | 1992999122 | Johnson | Charles | R | D.O. | M | I | 1601 Clint Moore Rd | 155 | Boca Raton | FL | 12.0 | 33487 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Internal Medicine | Y | G0439 | Annual wellness visit, includes a personalized prevention plan of service (pps), subsequent visit | N | O | 467 | 467 | 467 | $150.11 | $119.93 | $119.93 | $115.87 |
| 1419255 | 1992999270 | Bennett | Stephanie | R | PA-C | F | I | 5999 Dundee Rd | Suite 750 | Winter Haven | FL | 12.0 | 33884 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Physician Assistant | Y | 99214 | Established patient office or other outpatient, visit typically 25 minutes | N | O | 38 | 44 | 44 | $273.00 | $90.62 | $53.80 | $55.62 |
| 1419256 | 1992999437 | Rivera Mendez | Jose | L | M.D. | M | I | 1600 S Andrews Ave | NaN | Fort Lauderdale | FL | 12.0 | 33316 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Emergency Medicine | Y | 99284 | Emergency department visit, problem of high severity | N | F | 23 | 23 | 23 | $1,236.00 | $131.28 | $100.00 | $89.73 |
| 1419257 | 1992999551 | Molai | Indira | NaN | M.D. | F | I | 625 E Grand Ave | NaN | Escondido | CA | 6.0 | 92025 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Internal Medicine | Y | 81003 | Automated urinalysis test | N | O | 47 | 56 | 56 | $6.66 | $2.44 | $2.44 | $2.44 |
| 1419258 | 1992999551 | Molai | Indira | NaN | M.D. | F | I | 625 E Grand Ave | NaN | Escondido | CA | 6.0 | 92025 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Internal Medicine | Y | 90653 | Vaccine for influenza for injection into muscle | Y | O | 50 | 50 | 50 | $120.00 | $58.34 | $58.34 | $58.34 |
| 1419259 | 1992999775 | Spine Surgery Center Of Eugene, Llc | NaN | NaN | NaN | NaN | O | 1410 Oak St | Suite 300 | Eugene | OR | 41.0 | 97401 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Ambulatory Surgical Center | Y | 63047 | Partial removal of middle spine bone with release of spinal cord and/or nerves | N | F | 23 | 23 | 23 | $15,000.00 | $2,955.25 | $2,352.15 | $2,149.15 |
| 1419260 | 1992999825 | Deschenes | Geoffrey | R | M.D. | M | I | 1100 9th Ave | Ms:m4-Pfs | Seattle | WA | 53.0 | 98101 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Otolaryngology | Y | 30140 | Removal of nasal air passage | N | F | 11 | 11 | 11 | $1,819.50 | $159.64 | $117.02 | $108.50 |
| 1419261 | 1992999825 | Deschenes | Geoffrey | R | M.D. | M | I | 1100 9th Ave | Ms:m4-Pfs | Seattle | WA | 53.0 | 98101 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Otolaryngology | Y | 99203 | New patient office or other outpatient visit, typically 30 minutes | N | F | 29 | 29 | 29 | $150.00 | $81.53 | $60.69 | $56.54 |
| 1419262 | 1992999825 | Deschenes | Geoffrey | R | M.D. | M | I | 1100 9th Ave | Ms:m4-Pfs | Seattle | WA | 53.0 | 98101 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Otolaryngology | Y | 99214 | Established patient office or other outpatient, visit typically 25 minutes | N | F | 92 | 115 | 115 | $150.19 | $83.80 | $63.96 | $59.98 |